<!DOCTYPE HTML>
<html>
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">

    

    <title>Hibernate 映射数据库中Json字段的解决方案 | 钱猛的个人博客</title>
    <meta name="author" content="钱猛">
    
    <meta name="description" content="钱猛的个人博客。全栈发展向。无所谓做什么，只要是当前最感兴趣的事！随心、随性、随缘！">
    
    
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

    <meta property="og:title" content="Hibernate 映射数据库中Json字段的解决方案"/>
    <meta property="og:site_name" content="钱猛 &amp; 博客"/>

    
    <meta property="og:image" content="undefined"/>
    

    <link rel="icon" type="image/png" href="/qianmeng/favicon.png">
    <link rel="alternate" href="/qianmeng/atom.xml" title="钱猛 &amp; 博客" type="application/atom+xml">
    <link rel="stylesheet" href="/qianmeng/css/lib/materialize.min.css">
    <link rel="stylesheet" href="/qianmeng/css/lib/font-awesome.min.css">
    <link rel="stylesheet" href="/qianmeng/css/style.css" media="screen" type="text/css">

    
        <link rel="stylesheet" href="/qianmeng/css/lib/prettify-tomorrow-night-eighties.css" type="text/css">
    
    <!--[if lt IE 9]><script src="//html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
	<script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "https://hm.baidu.com/hm.js?fc7f849e9fbb3ea12b2683af4ccaa000";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script>

</head>


<body>
    <img src="/weixin_favicon.png" style="position: absolute; left: -9999px; opacity: 0; filter: alpha(opacity=0);">

    <nav class="indigo">
    <div class="nav-wrapper">
        <a href="#" data-activates="main-menu" class="button-collapse">
            <i class="fa fa-navicon"></i>
        </a>
        <div class="">
            <a href="/" class="brand-logo hide-on-med-and-down">钱猛 &amp; 博客 | 
			<span style="color:#E91E63;font-size:18px;">
			<i class="fa fa-flag"></i><span id="busuanzi_value_site_pv"></span>. 
			<i class="fa fa-user"></i><span id="busuanzi_value_site_uv"></span>
			</span> 
			</a> 
            <ul class="right hide-on-med-and-down">
                
                    <li>
                        <a class="menu-home " href="/qianmeng" >
                            <i class="fa fa-home "></i>
                            
                            首页
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-archive " href="/qianmeng/archives" >
                            <i class="fa fa-archive "></i>
                            
                            归档
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-category category-menu" href="javascript:;" data-activates="category-menu" >
                            <i class="fa fa-bookmark "></i>
                            
                            分类
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-tag " href="/qianmeng/tags" >
                            <i class="fa fa-tag "></i>
                            
                            标签
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-reading " href="/qianmeng/reading" >
                            <i class="fa fa-book "></i>
                            
                            读书
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-about " href="/qianmeng/about" >
                            <i class="fa fa-user "></i>
                            
                            关于
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-search modal-trigger " href="#search" >
                            <i class="fa fa-search "></i>
                            
                            搜索
                        </a>
                    </li>
                
            </ul>
            <div>
    <ul class="side-nav indigo darken-1" id="main-menu">
        
        <li class="side-user">
            <div class="row">
                <div class="col s4 no-padding">
                    <img class="avatar-image circle responsive-img" src="https://raw.githubusercontent.com/qianmeng/resources/master/head.jpg" alt="User Avatar">
                </div>
                <div class="info col s8 valign-wrapper no-padding">
                    <div class="valign">
                        <p class="name">钱猛</p>
                        <p class="desc">全栈工程师</p>
                    </div>
                </div>
            </div>
        </li>
        

        
            <li class="no-padding">
                <a class="waves-effect menu-home " href="/qianmeng" >
                    <i class="fa fa-home "></i>
                    
                    首页
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-archive " href="/qianmeng/archives" >
                    <i class="fa fa-archive "></i>
                    
                    归档
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-category category-menu" href="javascript:;" data-activates="category-menu" >
                    <i class="fa fa-bookmark "></i>
                    
                    分类
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-tag " href="/qianmeng/tags" >
                    <i class="fa fa-tag "></i>
                    
                    标签
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-reading " href="/qianmeng/reading" >
                    <i class="fa fa-book "></i>
                    
                    读书
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-about " href="/qianmeng/about" >
                    <i class="fa fa-user "></i>
                    
                    关于
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-search modal-trigger " href="#search" >
                    <i class="fa fa-search "></i>
                    
                    搜索
                </a>
            </li>
        
    </ul>

    <ul class="side-nav indigo darken-1" id="category-menu">
    

            

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/总结/">
                    总结 <span class="right">9 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/总结/个人总结/">
                    个人总结 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/总结/会展总结/">
                    会展总结 <span class="right">3 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/总结/个人技能/">
                    个人技能 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/总结/公司管理/">
                    公司管理 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/总结/编程经验/">
                    编程经验 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/面试/">
                    面试 <span class="right">6 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/面试/Android/">
                    Android <span class="right">3 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/面试/Python/">
                    Python <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/面试/web/">
                    web <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/面试/前端/">
                    前端 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/前端/">
                    前端 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/前端/AngularJs/">
                    AngularJs <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/后台/">
                    后台 <span class="right">5 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/后台/Apache-CXF/">
                    Apache-CXF <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/后台/Apache-Http-Server/">
                    Apache-Http-Server <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/后台/Ehcache/">
                    Ehcache <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/后台/Hibernate/">
                    Hibernate <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/后台/MetaQ/">
                    MetaQ <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/架构/">
                    架构 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/架构/Hexo/">
                    Hexo <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/量化交易/">
                    量化交易 <span class="right">5 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/量化交易/Matlab/">
                    Matlab <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/量化交易/股票/">
                    股票 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/量化交易/爬虫/">
                    爬虫 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/量化交易/期货/">
                    期货 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/数据库/">
                    数据库 <span class="right">5 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/数据库/PostGreSQL/">
                    PostGreSQL <span class="right">5 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/Android/">
                    Android <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/Android/Vollery/">
                    Vollery <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/IOS/">
                    IOS <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/IOS/itms-services/">
                    itms-services <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/网络/">
                    网络 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/网络/互联网协议/">
                    互联网协议 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/工具分享/">
                    工具分享 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/工具分享/系统工具/">
                    系统工具 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/微信/">
                    微信 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/微信/帐号区别/">
                    帐号区别 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/星座/">
                    星座 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/星座/归类/">
                    归类 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/星座/性格/">
                    性格 <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/qianmeng/categories/美女/">
                    美女 <span class="right">17 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/qianmeng/categories/美女/素人/">
                    素人 <span class="right">17 篇</span></a>
                </a>
            </li>

        

    </ul>
</div>

        </div>
    </div>
</nav>

<div id="search" class="modal search-modal">
    <div class="row">
        <div class="input-field col s12">
              <input id="search-input" type="text">
              <label for="search-input">搜索</label>
        </div>

    </div>
    <div id="search-result" class="search-result col s12">

    </div>
</div>


    <main>
        <div class="container main-container">
    
<nav class="page-nav hide-on-small-only">
    <div class="nav-wrapper indigo">
        <span class="breadcrumb">当前位置（分类目录）</span>
        
            
    
    
    <a class="breadcrumb" href="/qianmeng/categories/后台/">后台</a><a class="breadcrumb" href="/qianmeng/categories/后台/Hibernate/">Hibernate</a>


        

        
    </div>
</nav>

<article>
    <div class="card">
        <div class="card-content">
            

            <div class="article-title">
                
    
        <h1>Hibernate 映射数据库中Json字段的解决方案</h1>
    


            </div>
            <i class="fa fa-pencil-square"></i><time class="pink-link-context" datetime="2014-12-07T10:06:50.000Z"><a href="/qianmeng/2014/12/07/Hibernate 映射数据库中Json字段的解决方案/">2014-12-07</a></time>

			<i class="fa fa-flag"></i><span id="busuanzi_value_page_pv"><i class="fa fa-spinner"></i></span> 人点击
            
    <div class="tags-row">
        
            <a href="/qianmeng/tags/Hibernate/" class="chip pink lighten-1">Hibernate</a>
        
            <a href="/qianmeng/tags/PostgreSQL/" class="chip pink lighten-1">PostgreSQL</a>
        
    </div>


            <div class="toc pink-link-context hide-on-med-and-down">
    <ol class="section table-of-contents"><li class="section table-of-contents-item section table-of-contents-level-3"><a class="section table-of-contents-link" href="#现在有俩种方案"><span class="section table-of-contents-text">现在有俩种方案：</span></a><ol class="section table-of-contents-child"><li class="section table-of-contents-item section table-of-contents-level-4"><a class="section table-of-contents-link" href="#1-在数据库端处理"><span class="section table-of-contents-text">1、在数据库端处理</span></a></li><li class="section table-of-contents-item section table-of-contents-level-4"><a class="section table-of-contents-link" href="#2-在hibernate端处理"><span class="section table-of-contents-text">2、在Hibernate端处理</span></a></li></ol></li><li class="section table-of-contents-item section table-of-contents-level-3"><a class="section table-of-contents-link" href="#结论"><span class="section table-of-contents-text">结论</span></a></li></ol>
</div>


            <div class="entry pink-link-context">
                <p>&#x6700;&#x8FD1;&#x7684;&#x9879;&#x76EE;ORM&#x6846;&#x67B6;&#x4F7F;&#x7528;&#x7684;&#x662F;Hibernate&#xFF0C;&#x6570;&#x636E;&#x5E93;&#x4F7F;&#x7528;PostgreSQL&#xFF0C;&#x4FE9;&#x4E2A;&#x90FD;&#x662F;&#x5F00;&#x6E90;&#x7684;&#x9AD8;&#x5927;&#x4E0A;&#x4EA7;&#x54C1;&#xFF0C;Hibernate&#x5C31;&#x4E0D;&#x7528;&#x8BF4;&#x5566;&#xFF0C;&#x4E3B;&#x6D41;&#x7684;ORM&#x6846;&#x67B6;&#xFF0C;PostgreSQL&#x7B2C;&#x4E00;&#x6B21;&#x63A5;&#x89E6;&#xFF0C;&#x5176;&#x4E2D;&#x5305;&#x542B;Json&#x6570;&#x636E;&#x7C7B;&#x578B;&#x7684;&#x5B57;&#x6BB5;&#xFF0C;&#x8FD9;&#x79CD;&#x7C7B;&#x578B;&#x610F;&#x5473;&#x7740;&#x5B83;&#x53EF;&#x4EE5;&#x50CF;&#x975E;&#x5173;&#x7CFB;&#x578B;&#x6570;&#x636E;&#x5E93;&#x90A3;&#x6837;&#x5B58;&#x50A8;&#x6570;&#x636E;&#xFF0C;&#x6570;&#x636E;&#x6269;&#x5C55;&#x6027;&#x975E;&#x5E38;&#x597D;&#xFF0C;&#x8FD9;&#x4E5F;&#x662F;&#x9879;&#x76EE;&#x4F7F;&#x7528;&#x5B83;&#x7684;&#x4E3B;&#x8981;&#x539F;&#x56E0;&#x4E4B;&#x4E00;&#x3002; &#x5728;Hibernate&#x548C;PostgreSQL&#x7684;&#x7ED3;&#x5408;&#x8FC7;&#x7A0B;&#x4E2D;&#x9047;&#x5230;&#x4E86;&#x9488;&#x5BF9;Json&#x6570;&#x636E;&#x7C7B;&#x578B;&#xFF0C;Hibernate&#x5E76;&#x6CA1;&#x6709;Json&#x8FD9;&#x79CD;&#x6570;&#x636E;&#x6620;&#x5C04;&#x5B57;&#x6BB5;&#xFF0C;&#x60F3;&#x4E86;&#x4E0B;&#x662F;&#x4E0D;&#x662F;&#x7248;&#x672C;&#x7684;&#x95EE;&#x9898;&#xFF0C;&#x4E5F;&#x8BB8;&#x9AD8;&#x7248;&#x672C;Hibernate&#x5DF2;&#x7ECF;&#x652F;&#x6301;&#x8FD9;&#x79CD;&#x7C7B;&#x578B;&#x5566;&#xFF0C;&#x4E0B;&#x8F7D;&#x6700;&#x65B0;&#x7248;&#x672C;Hibernate&#x770B;&#x4E0B;&#x5566;&#xFF0C;&#x4ECD;&#x7136;&#x4E0D;&#x652F;&#x6301;&#xFF0C;&#x8FD9;&#x70B9;&#x4E0D;&#x662F;&#x5F88;&#x660E;&#x767D;&#xFF0C;PostgreSQL&#x5DF2;&#x7ECF;&#x652F;&#x6301;Json&#x8FD9;&#x4E48;&#x957F;&#x65F6;&#x95F4;&#x5566;&#xFF0C;&#x800C;&#x4E14;&#x73B0;&#x5728;MySQL&#x6700;&#x65B0;&#x7248;&#x672C;&#x4E5F;&#x5DF2;&#x7ECF;&#x652F;&#x6301;Json&#x6570;&#x636E;&#x683C;&#x5F0F;&#x5566;&#xFF0C;&#x8EAB;&#x4E3A;&#x4E3B;&#x6D41;ORM&#x6846;&#x67B6;&#x600E;&#x4E48;&#x5230;&#x73B0;&#x5728;&#x8FD8;&#x6CA1;&#x6709;&#x63D0;&#x4F9B;&#x8FD9;&#x79CD;&#x6570;&#x636E;&#x7C7B;&#x578B;&#xFF0C;&#x4E0D;&#x7BA1;&#x5566;&#xFF0C;&#x4E5F;&#x8BB8;&#x4EBA;&#x5BB6;&#x63D0;&#x4F9B;&#x4E86;&#x5176;&#x4ED6;&#x60F3;&#x6CD5;&#xFF0C;&#x5927;&#x516C;&#x53F8;&#x7684;&#x60F3;&#x6CD5;&#x662F;&#x6211;&#x4EEC;&#x8FD9;&#x4E9B;&#x540A;&#x79C1;&#x65E0;&#x6CD5;&#x731C;&#x6D4B;&#x7684;&#xFF0C;&#x4F5C;&#x4E3A;&#x6211;&#x4EEC;&#x5C31;&#x662F;&#x5BFB;&#x627E;&#x89E3;&#x51B3;&#x65B9;&#x6848;&#x5C31;&#x53EF;&#x4EE5;&#x5566;&#xFF0C;&#x6BD5;&#x7ADF;&#x4EBA;&#x5BB6;&#x5DF2;&#x7ECF;&#x5F00;&#x6E90;&#x4E86;&#x561B;&#x3002;<br>    &#x6BD5;&#x7ADF;&#x8FD9;&#x4FE9;&#x6846;&#x67B6;&#x5DF2;&#x7ECF;&#x8BDE;&#x751F;&#x8FD9;&#x4E48;&#x957F;&#x65F6;&#x95F4;&#x5566;&#xFF0C;&#x8FD9;&#x79CD;&#x5E38;&#x89C1;&#x95EE;&#x9898;&#x80AF;&#x5B9A;&#x6709;&#x4E86;&#x5F88;&#x597D;&#x7684;&#x89E3;&#x51B3;&#x65B9;&#x6848;&#xFF0C;&#x679C;&#x7136;&#x5728;stackoverflow&#x627E;&#x5230;&#x4E86;&#x4E00;&#x4E9B;&#x89E3;&#x51B3;&#x65B9;&#x6848;&#xFF0C;&#x8FD9;&#x91CC;&#x53EA;&#x505A;&#x6574;&#x7406;&#x8BF4;&#x660E;&#xFF0C;&#x80FD;&#x591F;&#x89E3;&#x51B3;&#x5F53;&#x524D;&#x9879;&#x76EE;&#x4E2D;&#x7684;&#x95EE;&#x9898;&#xFF0C;&#x4E0D;&#x505A;&#x6DF1;&#x5165;&#x63A2;&#x7A76;&#x3002;</p>
<a id="more"></a>
<h3 id="&#x73B0;&#x5728;&#x6709;&#x4FE9;&#x79CD;&#x65B9;&#x6848;"><a href="#&#x73B0;&#x5728;&#x6709;&#x4FE9;&#x79CD;&#x65B9;&#x6848;&#xFF1A;" class="headerlink" title="&#x73B0;&#x5728;&#x6709;&#x4FE9;&#x79CD;&#x65B9;&#x6848;&#xFF1A;"></a>&#x73B0;&#x5728;&#x6709;&#x4FE9;&#x79CD;&#x65B9;&#x6848;&#xFF1A;</h3><h4 id="1-&#x5728;&#x6570;&#x636E;&#x5E93;&#x7AEF;&#x5904;&#x7406;"><a href="#1&#x3001;&#x5728;&#x6570;&#x636E;&#x5E93;&#x7AEF;&#x5904;&#x7406;" class="headerlink" title="1&#x3001;&#x5728;&#x6570;&#x636E;&#x5E93;&#x7AEF;&#x5904;&#x7406;"></a>1&#x3001;&#x5728;&#x6570;&#x636E;&#x5E93;&#x7AEF;&#x5904;&#x7406;</h4><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br></pre></td><td class="code"><pre><span class="line">CREATE OR REPLACE FUNCTION json_intext(text) RETURNS json AS $$</span><br><span class="line">SELECT json_in($1::cstring); </span><br><span class="line">$$ LANGUAGE SQL IMMUTABLE;</span><br></pre></td></tr></table></figure>
<p>&#x4E0A;&#x9762;&#x7684;&#x51FD;&#x6570;&#x662F;&#x5C06;&#x6307;&#x5B9A;text&#x7C7B;&#x578B;&#x6570;&#x636E;&#x8F6C;&#x6362;&#x6210;json&#x6570;&#x636E;&#x4E2A;&#x6570;</p>
<h4 id="2-&#x5728;hibernate&#x7AEF;&#x5904;&#x7406;"><a href="#2&#x3001;&#x5728;Hibernate&#x7AEF;&#x5904;&#x7406;" class="headerlink" title="2&#x3001;&#x5728;Hibernate&#x7AEF;&#x5904;&#x7406;"></a>2&#x3001;&#x5728;Hibernate&#x7AEF;&#x5904;&#x7406;</h4><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br><span class="line">52</span><br><span class="line">53</span><br><span class="line">54</span><br><span class="line">55</span><br><span class="line">56</span><br><span class="line">57</span><br><span class="line">58</span><br><span class="line">59</span><br><span class="line">60</span><br><span class="line">61</span><br><span class="line">62</span><br><span class="line">63</span><br><span class="line">64</span><br><span class="line">65</span><br><span class="line">66</span><br><span class="line">67</span><br><span class="line">68</span><br><span class="line">69</span><br><span class="line">70</span><br><span class="line">71</span><br><span class="line">72</span><br><span class="line">73</span><br><span class="line">74</span><br><span class="line">75</span><br><span class="line">76</span><br><span class="line">77</span><br><span class="line">78</span><br><span class="line">79</span><br><span class="line">80</span><br><span class="line">81</span><br><span class="line">82</span><br><span class="line">83</span><br><span class="line">84</span><br><span class="line">85</span><br><span class="line">86</span><br><span class="line">87</span><br><span class="line">88</span><br><span class="line">89</span><br><span class="line">90</span><br><span class="line">91</span><br><span class="line">92</span><br><span class="line">93</span><br><span class="line">94</span><br><span class="line">95</span><br><span class="line">96</span><br><span class="line">97</span><br><span class="line">98</span><br><span class="line">99</span><br><span class="line">100</span><br><span class="line">101</span><br><span class="line">102</span><br><span class="line">103</span><br><span class="line">104</span><br><span class="line">105</span><br><span class="line">106</span><br><span class="line">107</span><br><span class="line">108</span><br><span class="line">109</span><br><span class="line">110</span><br><span class="line">111</span><br><span class="line">112</span><br><span class="line">113</span><br><span class="line">114</span><br><span class="line">115</span><br><span class="line">116</span><br><span class="line">117</span><br><span class="line">118</span><br><span class="line">119</span><br><span class="line">120</span><br><span class="line">121</span><br><span class="line">122</span><br><span class="line">123</span><br><span class="line">124</span><br><span class="line">125</span><br><span class="line">126</span><br><span class="line">127</span><br><span class="line">128</span><br><span class="line">129</span><br><span class="line">130</span><br><span class="line">131</span><br><span class="line">132</span><br><span class="line">133</span><br><span class="line">134</span><br><span class="line">135</span><br><span class="line">136</span><br><span class="line">137</span><br><span class="line">138</span><br><span class="line">139</span><br><span class="line">140</span><br><span class="line">141</span><br><span class="line">142</span><br><span class="line">143</span><br><span class="line">144</span><br><span class="line">145</span><br><span class="line">146</span><br><span class="line">147</span><br><span class="line">148</span><br><span class="line">149</span><br><span class="line">150</span><br><span class="line">151</span><br><span class="line">152</span><br><span class="line">153</span><br><span class="line">154</span><br><span class="line">155</span><br><span class="line">156</span><br><span class="line">157</span><br><span class="line">158</span><br><span class="line">159</span><br><span class="line">160</span><br><span class="line">161</span><br><span class="line">162</span><br><span class="line">163</span><br><span class="line">164</span><br><span class="line">165</span><br><span class="line">166</span><br><span class="line">167</span><br><span class="line">168</span><br><span class="line">169</span><br><span class="line">170</span><br><span class="line">171</span><br><span class="line">172</span><br><span class="line">173</span><br><span class="line">174</span><br><span class="line">175</span><br><span class="line">176</span><br><span class="line">177</span><br><span class="line">178</span><br><span class="line">179</span><br></pre></td><td class="code"><pre><span class="line">import org.hibernate.HibernateException;</span><br><span class="line">import org.hibernate.engine.spi.SessionImplementor;</span><br><span class="line">import org.hibernate.usertype.UserType;</span><br><span class="line"></span><br><span class="line">import java.io.Serializable;</span><br><span class="line">import java.sql.PreparedStatement;</span><br><span class="line">import java.sql.ResultSet;</span><br><span class="line">import java.sql.SQLException;</span><br><span class="line">import java.sql.Types;</span><br><span class="line"></span><br><span class="line">/**</span><br><span class="line"> * @author timfulmer</span><br><span class="line"> */</span><br><span class="line">public class StringJsonUserType implements UserType {</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Return the SQL type codes for the columns mapped by this type. The</span><br><span class="line">     * codes are defined on &lt;tt&gt;java.sql.Types&lt;/tt&gt;.</span><br><span class="line">     *</span><br><span class="line">     * @return int[] the typecodes</span><br><span class="line">     * @see java.sql.Types</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public int[] sqlTypes() {</span><br><span class="line">        return new int[] { Types.JAVA_OBJECT};</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * The class returned by &lt;tt&gt;nullSafeGet()&lt;/tt&gt;.</span><br><span class="line">     *</span><br><span class="line">     * @return Class</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public Class returnedClass() {</span><br><span class="line">        return String.class;</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Compare two instances of the class mapped by this type for persistence &quot;equality&quot;.</span><br><span class="line">     * Equality of the persistent state.</span><br><span class="line">     *</span><br><span class="line">     * @param x</span><br><span class="line">     * @param y</span><br><span class="line">     * @return boolean</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public boolean equals(Object x, Object y) throws HibernateException {</span><br><span class="line"></span><br><span class="line">        if( x== null){</span><br><span class="line"></span><br><span class="line">            return y== null;</span><br><span class="line">        }</span><br><span class="line"></span><br><span class="line">        return x.equals( y);</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Get a hashcode for the instance, consistent with persistence &quot;equality&quot;</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public int hashCode(Object x) throws HibernateException {</span><br><span class="line"></span><br><span class="line">        return x.hashCode();</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Retrieve an instance of the mapped class from a JDBC resultset. Implementors</span><br><span class="line">     * should handle possibility of null values.</span><br><span class="line">     *</span><br><span class="line">     * @param rs      a JDBC result set</span><br><span class="line">     * @param names   the column names</span><br><span class="line">     * @param session</span><br><span class="line">     * @param owner   the containing entity  @return Object</span><br><span class="line">     * @throws org.hibernate.HibernateException</span><br><span class="line">     *</span><br><span class="line">     * @throws java.sql.SQLException</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor session, Object owner) throws HibernateException, SQLException {</span><br><span class="line">        if(rs.getString(names[0]) == null){</span><br><span class="line">            return null;</span><br><span class="line">        }</span><br><span class="line">        return rs.getString(names[0]);</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Write an instance of the mapped class to a prepared statement. Implementors</span><br><span class="line">     * should handle possibility of null values. A multi-column type should be written</span><br><span class="line">     * to parameters starting from &lt;tt&gt;index&lt;/tt&gt;.</span><br><span class="line">     *</span><br><span class="line">     * @param st      a JDBC prepared statement</span><br><span class="line">     * @param value   the object to write</span><br><span class="line">     * @param index   statement parameter index</span><br><span class="line">     * @param session</span><br><span class="line">     * @throws org.hibernate.HibernateException</span><br><span class="line">     *</span><br><span class="line">     * @throws java.sql.SQLException</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public void nullSafeSet(PreparedStatement st, Object value, int index, SessionImplementor session) throws HibernateException, SQLException {</span><br><span class="line">        if (value == null) {</span><br><span class="line">            st.setNull(index, Types.OTHER);</span><br><span class="line">            return;</span><br><span class="line">        }</span><br><span class="line"></span><br><span class="line">        st.setObject(index, value, Types.OTHER);</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Return a deep copy of the persistent state, stopping at entities and at</span><br><span class="line">     * collections. It is not necessary to copy immutable objects, or null</span><br><span class="line">     * values, in which case it is safe to simply return the argument.</span><br><span class="line">     *</span><br><span class="line">     * @param value the object to be cloned, which may be null</span><br><span class="line">     * @return Object a copy</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public Object deepCopy(Object value) throws HibernateException {</span><br><span class="line"></span><br><span class="line">        return value;</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Are objects of this type mutable?</span><br><span class="line">     *</span><br><span class="line">     * @return boolean</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public boolean isMutable() {</span><br><span class="line">        return true;</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Transform the object into its cacheable representation. At the very least this</span><br><span class="line">     * method should perform a deep copy if the type is mutable. That may not be enough</span><br><span class="line">     * for some implementations, however; for example, associations must be cached as</span><br><span class="line">     * identifier values. (optional operation)</span><br><span class="line">     *</span><br><span class="line">     * @param value the object to be cached</span><br><span class="line">     * @return a cachable representation of the object</span><br><span class="line">     * @throws org.hibernate.HibernateException</span><br><span class="line">     *</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public Serializable disassemble(Object value) throws HibernateException {</span><br><span class="line">        return (String)this.deepCopy( value);</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * Reconstruct an object from the cacheable representation. At the very least this</span><br><span class="line">     * method should perform a deep copy if the type is mutable. (optional operation)</span><br><span class="line">     *</span><br><span class="line">     * @param cached the object to be cached</span><br><span class="line">     * @param owner  the owner of the cached object</span><br><span class="line">     * @return a reconstructed object from the cachable representation</span><br><span class="line">     * @throws org.hibernate.HibernateException</span><br><span class="line">     *</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public Object assemble(Serializable cached, Object owner) throws HibernateException {</span><br><span class="line">        return this.deepCopy( cached);</span><br><span class="line">    }</span><br><span class="line"></span><br><span class="line">    /**</span><br><span class="line">     * During merge, replace the existing (target) value in the entity we are merging to</span><br><span class="line">     * with a new (original) value from the detached entity we are merging. For immutable</span><br><span class="line">     * objects, or null values, it is safe to simply return the first parameter. For</span><br><span class="line">     * mutable objects, it is safe to return a copy of the first parameter. For objects</span><br><span class="line">     * with component values, it might make sense to recursively replace component values.</span><br><span class="line">     *</span><br><span class="line">     * @param original the value from the detached entity being merged</span><br><span class="line">     * @param target   the value in the managed entity</span><br><span class="line">     * @return the value to be merged</span><br><span class="line">     */</span><br><span class="line">    @Override</span><br><span class="line">    public Object replace(Object original, Object target, Object owner) throws HibernateException {</span><br><span class="line">        return original;</span><br><span class="line">    }</span><br><span class="line">}</span><br></pre></td></tr></table></figure>
<p>&#x4E0A;&#x9762;&#x7684;&#x7C7B;&#x5B9E;&#x73B0;Hibernate&#x7684;UserType&#x63A5;&#x53E3;&#xFF0C;&#x8FD9;&#x6837;&#x5C31;&#x53EF;&#x4EE5;&#x5B9A;&#x4E49;Hibernate&#x7AEF;&#x7684;&#x6570;&#x636E;&#x7C7B;&#x578B;&#xFF0C;&#x8FD9;&#x6837;&#x5C06;&#x5BF9;&#x5E94;&#x6570;&#x636E;&#x5E93;&#x4E2D;Json&#x5B57;&#x6BB5;&#x7684;JavaBean&#x4E2D;&#x7684;&#x6570;&#x636E;&#x5B57;&#x6BB5;&#x5B9A;&#x4E49;&#x6210;String&#x7C7B;&#x578B;&#xFF0C;&#x8FD9;&#x6837;javaBean&#x4E2D;&#x6307;&#x5B9A;&#x5B57;&#x6BB5;&#x5C31;&#x80FD;&#x548C;&#x6570;&#x636E;&#x5E93;&#x4E2D;json&#x5F62;&#x6210;&#x6620;&#x5C04;</p>
<p>&#x4F8B;&#x5982;</p>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br></pre></td><td class="code"><pre><span class="line">&lt;property name=&quot;atts&quot; type=&quot;com.quangao.hibernate.StringJsonUserType&quot;&gt;</span><br><span class="line">     &lt;column name=&quot;atts&quot;  /&gt;</span><br><span class="line">&lt;/property&gt;</span><br></pre></td></tr></table></figure>
<p>&#x8FD9;&#x6837;session.save(entity);&#x7684;&#x65F6;&#x5019;&#x5C31;&#x53EF;&#x4EE5;&#x5C06;json&#x5B57;&#x6BB5;&#x6210;&#x529F;&#x4FDD;&#x5B58;</p>
<h3 id="&#x7ED3;&#x8BBA;"><a href="#&#x7ED3;&#x8BBA;" class="headerlink" title="&#x7ED3;&#x8BBA;"></a>&#x7ED3;&#x8BBA;</h3><p>&#x4E0A;&#x8FF0;&#x4FE9;&#x79CD;&#x65B9;&#x6CD5;&#xFF0C;&#x7B2C;&#x4E00;&#x79CD;&#x867D;&#x80FD;&#x5B9E;&#x73B0;&#xFF0C;&#x4F46;&#x9700;&#x5728;&#x6570;&#x636E;&#x4E2D;&#x9891;&#x7E41;&#x8F6C;&#x6362;&#xFF0C;&#x672C;&#x8EAB;&#x7B80;&#x5355;&#x7684;&#x4FDD;&#x5B58;&#x4FEE;&#x6539;&#x53D8;&#x5F97;&#x5F88;&#x9EBB;&#x70E6;&#xFF0C;&#x660E;&#x663E;&#x4E0D;&#x5207;&#x7B26;&#x5408;&#x89E3;&#x8026;&#x6982;&#x5FF5;&#xFF0C;&#x8FD9;&#x662F;&#x5C06;&#x524D;&#x7AEF;&#x7684;&#x4E8B;&#x60C5;&#x5F3A;&#x52A0;&#x7ED9;&#x6570;&#x636E;&#x5E93;&#x6765;&#x5904;&#x7406;&#x7684;&#xFF0C;&#x800C;&#x4E14;&#x4E0D;&#x7B26;&#x5408;Hibernate&#x5B58;&#x5728;&#x7684;&#x539F;&#x56E0;&#xFF0C;&#x4E8C;&#x7B2C;&#x4E8C;&#x79CD;&#x65B9;&#x6CD5;&#x5F88;&#x597D;&#x7684;&#x5B9E;&#x73B0;&#x4E86;&#x6240;&#x8C13;&#x7684;&#x6620;&#x5C04;&#x5173;&#x7CFB;&#xFF0C;&#x6570;&#x636E;&#x5E93;&#x7AEF;&#x4E0D;&#x9700;&#x8981;&#x505A;&#x4EFB;&#x4F55;&#x591A;&#x4F59;&#x7684;&#x4E8B;&#x60C5;&#x3002;&#x6240;&#x4EE5;&#x6211;&#x9009;&#x62E9;&#x4E86;&#x7B2C;&#x4E8C;&#x79CD;&#x65B9;&#x6848;&#x3002;</p>

            </div>
        </div>
    </div>
</article>  
<div class="card"> 
	 <nav id="pagination" class="indigo" >
		
		<a style="float: left;" href="/qianmeng/2015/02/07/itms-services协议，不通过AppStore，直接安装IOS应用程序/" >&nbsp;&nbsp;&nbsp;&nbsp;<i class="fa fa-arrow-left"></i>&nbsp;&nbsp;上一页</a>
		
		
		<a style="float: right;" href="/qianmeng/2014/08/01/MetaQ 简单使用（数据同步框架）/" >&nbsp;&nbsp;&nbsp;&nbsp;下一页&nbsp;&nbsp;<i class="fa fa-arrow-right"></i>&nbsp;&nbsp;&nbsp;&nbsp;</a>
		
		<div class="clearfix"></div>
	</nav> 
</div>





    <section id="comment">
        <div class="card">
            <div class="card-content">
                <!-- Duoshuo Comment BEGIN -->
                <div class="ds-thread" data-thread-key="2014/12/07/Hibernate 映射数据库中Json字段的解决方案/" data-title="Hibernate 映射数据库中Json字段的解决方案" data-url="https://kidmid.gitee.io/qianmeng/qianmeng/2014/12/07/Hibernate 映射数据库中Json字段的解决方案/"></div>

                <script type="text/javascript">
                    console.log(document.querySelector('.ds-thread'));
                    var duoshuoQuery = {
                        short_name: 'kidmid'
                    };
                    (function() {
                        var ds = document.createElement('script');
                        ds.type = 'text/javascript';
                        ds.async = true;
                        ds.src = (document.location.protocol == 'https:'
                            ? 'https:'
                            : 'http:') + '//static.duoshuo.com/embed.js';
                        ds.charset = 'UTF-8';
                        (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ds);
                    })();
                </script>
                <!-- Duoshuo Comment END -->
            </div>
        </div>
    </section>



</div>

        <div class="fixed-action-btn float-sitemap">
    <a class="btn-floating btn-large pink">
      <i class="fa fa-caret-square-o-up"></i>
    </a>
    <ul>
      <li><a class="btn-return-top btn-floating waves-effect green" title="回到顶部"><i class="fa fa-arrow-circle-o-up"></i></a></li>
      <li><a class="btn-floating waves-effect button-collapse yellow darken-1"  data-activates="main-menu" title="menu"><i class="fa fa-navicon"></i></a></li>
    </ul>
  </div>

    </main>
    <footer class="page-footer indigo darken-1">
    
    <div class="container">
        <div class="row">
            
            <div class="social-group col m3 s12">
                <h5 class="white-text">社交</h5>
                
                    <a class="social-link" href="https://github.com/qianmeng" target="_blank">
                        <i class="fa fa-2x fa-github"></i>
                    </a>
                
                    <a class="social-link" href="http://weibo.com/u/1819068247" target="_blank">
                        <i class="fa fa-2x fa-weibo"></i>
                    </a>
                
                    <a class="social-link" href="/atom.xml" target="_blank">
                        <i class="fa fa-2x fa-rss"></i>
                    </a>
                
            </div>
            

            
            <div class="col m9 s12">
                <h5 class="white-text">友情链接</h5>
                
                    <a class="social-link" href="http://blog.csdn.net/qian_meng" target="_blank">CSDN 地址</a>
                
                    <a class="social-link" href="https://github.com/qianmeng" target="_blank">Github地址</a>
                
            </div>
            
        </div>
    </div>
    

    <div class="footer-copyright pink-link-context">
        <div class="container">
            © 2016  All rights reserved. 
        </div>
    </div>
</footer> 
<script async src="https://dn-lbstatics.qbox.me/busuanzi/2.3/busuanzi.pure.mini.js">
</script>


    <noscript>
    <div class="noscript">
        <p class="center-align">当前网速较慢或者你使用的浏览器不支持博客特定功能，请尝试刷新或换用Chrome、Firefox等现代浏览器</p>
    </div>
</noscript>
<div class="noscript">
    <p class="center-align">当前网速较慢或者你使用的浏览器不支持博客特定功能，请尝试刷新或换用Chrome、Firefox等现代浏览器</p>
</div>


<script src="/qianmeng/js/jquery-2.1.1.min.js"></script>
<script src="/qianmeng/js/materialize.min.js"></script>

<script>
    (function($) {
        $(document).ready(function() {
            // 隐藏禁用javascript（针对微信内置浏览器）的提示
            $('.noscript').hide();

            // 图片缩放效果
            var $imgs = $('img').not('.slider-image').not('.avatar-image').not('.carousel-image').not('.card-cover-image').not('.qrcode');

            // 给图片加上点击放大效果（materialbox插件）
            $imgs.addClass('materialboxed').each(function(i, el) {
                $(this).attr('data-caption', $(this).attr('alt') || ' ');
            }).materialbox();

            // 优化表格的显示
            $('table').each(function() {
                var $table = $(this);
                // 除去多行代码的情况
                if ($table.find('pre').length == 0) {
                    $table.addClass('responsive-table striped bordered');
                }
            });

            // 首页幻灯片
            $('.slider').slider({indicators: true, full_width: true, interval: 8000});

            $(".button-collapse").sideNav();
            $(".category-menu").sideNav();

            // 针对gallery post
            $('.carousel').carousel({full_width: true});
            $('.carousel-control.prev').click(function() {
                $('.carousel').carousel('prev');
            });
            $('.carousel-control.next').click(function() {
                $('.carousel').carousel('next');
            });

            // 文章目录
            $('article').not('.simple-article').find('h1').add('h2').add('h3').add('h4').add('h5').add('h6').scrollSpy();
            // 修正文章目录的left-border颜色
            var color = $('.table-of-contents-text').css('color');
            $('.table-of-contents-link').css('border-left-color', color);

            // 针对移动端做的优化：FAB按钮点击一下收回
            if (/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent)) {
                $('.fixed-action-btn').addClass('click-to-toggle');
            }
            // 回到顶部
            $('.btn-return-top').click(function() {
                $('body, html').animate({
                    scrollTop: 0
                }, 500);
            });

            // 重置读书页面的Tab标签页的颜色
            $('li.tab a').hover(function() {
                $(this).toggleClass('text-lighten-4');
            });
            $('.indicator').addClass('pink lighten-2');

            
            // 添加new标签
            $('.menu-search').append('<span class="new badge pink"></span>');
            

            // 搜索功能
            $('.modal-trigger').leanModal();
            var searchXml = "search.xml";
            if (searchXml.length == 0) {
             	searchXml = "search.xml";
            }
            var searchPath = "/qianmeng/" + searchXml;
            initSearch(searchPath, 'search-input', 'search-result');
        });

        // 初始化搜索与匹配函数
        var initSearch = function(path, search_id, content_id) {
            'use strict';
            $.ajax({
                url: path,
                dataType: "xml",
                success: function(xmlResponse) {
                    // get the contents from search data
                    var datas = $("entry", xmlResponse).map(function() {
                        return {
                            title: $("title", this).text(),
                            content: $("content", this).text(),
                            url: $("url", this).text()
                        };
                    }).get();
                    var $input = document.getElementById(search_id);
                    var $resultContent = document.getElementById(content_id);
                    $input.addEventListener('input', function() {
                        var str = '<ul class=\"search-result-list\">';
                        var keywords = this.value.trim().toLowerCase().split(/[\s\-]+/);
                        $resultContent.innerHTML = "";
                        if (this.value.trim().length <= 0) {
                            return;
                        }
                        // perform local searching
                        datas.forEach(function(data) {
                            var isMatch = true;
                            var content_index = [];
                            var data_title = data.title.trim().toLowerCase();
                            var data_content = data.content.trim().replace(/<[^>]+>/g, "").toLowerCase();
                            var data_url = data.url;
                            var index_title = -1;
                            var index_content = -1;
                            var first_occur = -1;
                            // only match artiles with not empty titles and contents
                            if (data_title != '' && data_content != '') {
                                keywords.forEach(function(keyword, i) {
                                    index_title = data_title.indexOf(keyword);
                                    index_content = data_content.indexOf(keyword);
                                    if (index_title < 0 && index_content < 0) {
                                        isMatch = false;
                                    } else {
                                        if (index_content < 0) {
                                            index_content = 0;
                                        }
                                        if (i == 0) {
                                            first_occur = index_content;
                                        }
                                    }
                                });
                            }
                            // show search results
                            if (isMatch) {
                                keywords.forEach(function(keyword) {
                                    var regS = new RegExp(keyword, "gi");
                                    data_title = data_title.replace(regS, "<span class=\"search-keyword pink lighten-2\">" + keyword + "</span>");
                                });

                                str += "<li><a href='" + data_url + "' class='search-result-title'>" + data_title + "</a>";
                                var content = data.content.trim().replace(/<[^>]+>/g, "");
                                if (first_occur >= 0) {
                                    // cut out 100 characters
                                    var start = first_occur - 20;
                                    var end = first_occur + 80;
                                    if (start < 0) {
                                        start = 0;
                                    }
                                    if (start == 0) {
                                        end = 100;
                                    }
                                    if (end > content.length) {
                                        end = content.length;
                                    }
                                    var match_content = content.substring(start, end);
                                    // highlight all keywords
                                    keywords.forEach(function(keyword) {
                                        var regS = new RegExp(keyword, "gi");
                                        match_content = match_content.replace(regS, "<span class=\"search-keyword pink lighten-2\">" + keyword + "</span>");
                                    });

                                    str += "<p class=\"search-result\">..." + match_content + "...</p>"
                                }
                                str += "</li>";
                            }
                        });
                        str += "</ul>";
                        $resultContent.innerHTML = str;
                    });
                }
            });
        }
    })(jQuery);
</script>


<script src="/qianmeng/js/prettify.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $("pre").addClass("prettyprint");
        prettyPrint();
    });
</script>




<script type="text/javascript" src="http://tajs.qq.com/stats?sId=56073371" charset="UTF-8"></script>



<script type="text/x-mathjax-config">
MathJax.Hub.Config({
  tex2jax: {inlineMath: [['$','$'], ['\\(','\\)']]}
});
</script>
<script type="text/javascript" async
  src="//cdn.mathjax.org/mathjax/latest/MathJax.js?config=TeX-MML-AM_CHTML">
</script>



	<script>window._bd_share_config={"common":{"bdSnsKey":{},"bdText":"","bdMini":"2","bdMiniList":false,"bdPic":"","bdStyle":"0","bdSize":"16"},"slide":{"type":"slide","bdImg":"6","bdPos":"right","bdTop":"145"},"image":{"viewList":["qzone","tsina","tqq","renren","weixin"],"viewText":"分享到：","viewSize":"16"},"selectShare":{"bdContainerClass":null,"bdSelectMiniList":["qzone","tsina","tqq","renren","weixin"]}};with(document)0[(getElementsByTagName('head')[0]||body).appendChild(createElement('script')).src='http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion='+~(-new Date()/36e5)];</script>

</body>
</html>
